Notes/Domino 6 and 7 Forum : RE: Accessing DB2 via I need a sample code for connecting to DB2 using JAVA from Notes

Here is some sample code you can use to connect to DB2 using Java from Notes...

import java.awt.event.*;
import java.awt.*;
import javax.swing.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import java.util.*;

import lotus.domino.*;

public class dxdocumentation extends NotesThread
{
protected static Connection connection = null;
protected static String szInputFile = null;

.
.
.

public static void main(String[] args)
{
if ((args[0].equalsIgnoreCase("IBM") == false) &&
(args[0].equalsIgnoreCase("ORACLE") == false) &&
(args[0].equalsIgnoreCase("Symantec") == false))
{
System.exit(0);
}

try
{
if (args[0].equalsIgnoreCase("IBM") == true)
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
else if (args[0].equalsIgnoreCase("ORACLE") == true)
Class.forName("oracle.jdbc.driver.OracleDriver");
else
Class.forName("symantec.itools.db.jdbc.Driver");
}
catch (Exception e)
{
System.out.println(e);
}
}

public void runNotes()
{
try
{
.
.
.
}
catch (SQLException sqle)
{
sqle.printStackTrace();
System.exit(-1);
}
catch (java.io.IOException ioe)
{
ioe.printStackTrace();
System.exit(-1);
}
catch (Exception e)
{
e.printStackTrace();
System.exit(-1);
}
}

public static void getDocumentationInformation()
throws java.io.IOException,
Exception
{
Database db = null;

.
.
.

connection = DriverManager.getConnection(szInputFile);

System.out.println("connected...");

.
.
.

connection.close();

System.out.println("closed...");
.
.
.

}

.
.
.
}

Notes/Domino 6 and 7 Forum

Document Options

Search this forum

Forum views and search

Member Tools

RSS Feeds